Algorithmic Resolution of an ER Schema into Relational DDL Statements using Artificial Intelligence

The concept of this paper helps resolve an ER schema into an appropriate relational Data Description Language (herein standard SQL statements) while considering all the inherent complexity of such a schema. The algorithm resolves all the relationships between the concerned entities (even weak ones), their associated keys – primary and foreign, attributes – simple, composite and multivalued and relationships types from binary to nary. The algorithm (as implemented in ANSI C) is smart enough to consider the case of cascading weak entities.